Add tables or queries to relationships window
Do the following in the 'Show Table' dialog box in the Relationships window:
NOTE: If there are no relationships currently in the database, the 'Show Table' dialog box appears on top of the Relationships window when 'Relationships' is selected from the 'Tools' menu. If the 'Show Table' dialog box does not appear, select the 'Relationships' menu and select 'Show Table...'. (The Show Table dialog box appears.)
1) Choose the desired tab.
NOTE: The three available tabs are 'Table', 'Query', or 'Both'. Choose 'Table' to display a list of tables only. Choose 'Query' to display a list of queries only. Choose 'Both' to display a list of both tables and queries.
2) Select a table or query from the list box.
3) Choose the 'Add' button.
4) Repeat steps 2) and 3) for each table or query to add.
5) Choose the 'Close' button when finished.